using Front._1117_2;
using MySqlConnector;

namespace Front._1127;

public partial class login : Form
{
    public login()
    {
        InitializeComponent();
    }

  
    private void button1_Click(object sender, EventArgs e)
    {
        using var connection = new MySqlConnection("server=localhost;port=3306;database=book;user=root;password=WJM0816;charset=utf8mb4;AllowPublicKeyRetrieval=True");
        connection.Open();
        
        string sql = "SELECT * FROM admin_info where damin_account = @account and admin_password = @pwd;";
        using var command = new MySqlCommand(sql, connection);
        //获取账号密码
        string account = this.textBox1.Text;
        string password = this.textBox2.Text;
        //对密码进行MD5加密
        string pwd = MD5Helper.GetMD5(password);
        //给sql传参
        command.Parameters.AddWithValue("@account", account);
        command.Parameters.AddWithValue("@pwd", pwd);
        
        using var reader = command.ExecuteReader();
        if (reader.HasRows)
        {
            // 登陆成功，跳转主窗体
        }
        else
        {
            // 登陆失败
            MessageBox.Show( "账号或密码错误");
            this.textBox1.Text = "";
            this.textBox2.Text = "";
        }

    }

    private void textBox1_TextChanged(object sender, EventArgs e)
    {
        throw new System.NotImplementedException();
    }
}